Diagram GEN_Identifier

Defincja diagramu GEN_Identifier

Name

GEN_Identifier

Code

GEN_Identifier

Comment

Defines identifier to be connected to any information level (like documentation number, ...)


Lista tabel diagramu

Name

Code

Action

Action

Ambulance

Ambulance

Attribute

Attribute

AvailableNumbers

AvailableNumbers

Counter

Counter

DescriptiveData

DescriptiveData

DictionaryValue

DictionaryValue

Episode

Episode

Event

Event

ExternalIdentifier

ExternalIdentifier

ExternalIdentifierStatus

ExternalIdentifierStatus

ExternalIdentifierStatusText

ExternalIdentifierStatusText

FormInstance

FormInstance

IdentifierType

IdentifierType

IdentifierTypeText

IdentifierTypeText

LAmbulanceDescriptiveData

LAmbulanceDescriptiveData

LCounterAttribute

LCounterAttribute

LDescriptiveDataIdentifier

LDescriptiveDataIdentifier

LEpisodeIdentifier

LEpisodeIdentifier

LEventIdentifier

LEventIdentifier

Location

Location

LocationText

LocationText

LOrderIdentifier

LOrderIdentifier

LPatientIdentifier

LPatientIdentifier

LPerfServiceIdentifier

LPerfServiceIdentifier

LPerfServOrderEditPermission

LPerfServOrderEditPermission

LPersonIdentifier

LPersonIdentifier

LPrintingDataPerfServ

LPrintingDataPerfServ

LSampleIdentifier

LSampleIdentifier

NextExternalIdentifier

NextExternalIdentifier

OrderItem

OrderItem

Patient

Patient

PerfService

PerfService

Person

Person

PrintingData

PrintingData

Sample

Sample

SysFct

SysFct


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_46

R_46

IdentifierType

IdentifierTypeText

IdentifierTypeID

 

 

R_48

R_48

IdentifierType

ExternalIdentifier

IdentifierTypeID

 

 

R_52

R_52

Episode

LEpisodeIdentifier

EpisodeID

 

 

R_53

R_53

Event

LEventIdentifier

EventID

 

 

R_167

R_167

IdentifierType

AvailableNumbers

IdentifierTypeID

 

 

R_221

R_221

ExternalIdentifier

LOrderIdentifier

IdentifierTypeID; ExternalValue

 

 

R_224

R_224

OrderItem

LOrderIdentifier

OrderID

 

 

R_225

R_225

ExternalIdentifier

LDescriptiveDataIdentifier

IdentifierTypeID; ExternalValue

 

 

R_226

R_226

DescriptiveData

LDescriptiveDataIdentifier

DescriptiveDataID

 

 

R_322

R_322

Person

LPersonIdentifier

PersonID

 

 

R_343

R_343

Patient

Episode

PersonID

 

 

R_374

R_374

Location

ExternalIdentifier

LocationID

 

 

R_375

R_375

Location

LocationText

LocationID

 

 

R_377

R_377

NextExternalIdentifier

AvailableNumbers

NextExternalIdentifierID

 

 

R_419

R_419

Patient

LPatientIdentifier

PersonID

 

 

R_420

R_420

ExternalIdentifier

LPersonIdentifier

IdentifierTypeID; ExternalValue

 

 

R_421

R_421

ExternalIdentifier

LPatientIdentifier

IdentifierTypeID; ExternalValue

 

 

R_422

R_422

ExternalIdentifier

LEpisodeIdentifier

IdentifierTypeID; ExternalValue

 

 

R_423

R_423

ExternalIdentifier

LEventIdentifier

IdentifierTypeID; ExternalValue

 

 

R_447

R_447

IdentifierType

NextExternalIdentifier

IdentifierTypeID

 

 

R_590

R_590

Episode

Event

EpisodeID

 

 

R_648

R_648

NextExternalIdentifier

ExternalIdentifier

NextExternalIdentifierID

 

 

R_688

R_688

ExternalIdentifier

LPerfServiceIdentifier

IdentifierTypeID; ExternalValue

 

 

R_689

R_689

PerfService

LPerfServiceIdentifier

PerfServiceID

 

 

R_1573

R_1573

Sample

LSampleIdentifier

SampleID

 

 

R_1574

R_1574

ExternalIdentifier

LSampleIdentifier

IdentifierTypeID; ExternalValue

 

 

R_1961

R_1961

FormInstance

DescriptiveData

FormInstanceID

 

 

R_7010

R_7010

ExternalIdentifierStatus

ExternalIdentifierStatusText

ExternalIdentifierStatusID

 

 

R_8010

R_8010

Person

LPerfServOrderEditPermission

PersonID

 

 

R_8011

R_8011

PerfService

LPerfServOrderEditPermission

PerfServiceID

 

 

R_9256

R_9256

SysFct

PrintingData

SysFctID

 

 

R_9257

R_9257

PerfService

LPrintingDataPerfServ

PerfServiceID

 

 

R_9258

R_9258

PrintingData

LPrintingDataPerfServ

PrintingDataID

 

 

R_10171

R_10171

PerfService

OrderItem

CollectionPerfServID

 

 

R_10280

R_10280

Person

Ambulance

PersonID

 

 

R_10281

R_10281

DictionaryValue

Ambulance

StatusID

 

 

R_10282

R_10282

Ambulance

LAmbulanceDescriptiveData

AmbulanceID

 

 

R_10283

R_10283

DescriptiveData

LAmbulanceDescriptiveData

DescriptiveDataID

 

 

R_10371

R_10371

Counter

LCounterAttribute

CounterID

 

 

R_10372

R_10372

NextExternalIdentifier

LCounterAttribute

NextExternalIdentifierID

 

 

R_10373

R_10373

Attribute

LCounterAttribute

AttributeID